home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Freesoft 1997 May
/
Freesoft_1997-05_cd.bin
/
nerecenz
/
network, comunications
/
SENTRYNT
/
APPSAGS.CAB
/
sentry.sql
Wrap
Text File
|
1997-01-13
|
5KB
|
184 lines
/* Microsoft SQL Server - Scripting */
/* Server: SERVERWR05 */
/* Database: sentry */
/* Creation Date 10/04/96 16:08:39 */
/****************************************************************/
/* This is the SQL Server script file created from the "sentry" */
/* database. You can modify this script as an aid to creating */
/* your own database to support SeNTry. */
/* */
/* YOU MUST BE IN THE SENTRY DATABASE BEFORE RUNNING THIS QUERY */
/* */
/* */
/* You can change logins and users as needed to conform to your */
/* security guidelines, but please note that the user specified */
/* in the ODBC data source must have sufficient permissions to */
/* allow insertion and deletion of rows. */
/* Please read the Installation Guide for further information */
/****************************************************************/
/* this will create a login for user 'sentry'. The default database */
/* 'sentry' is selected for this user */
/****** Object: Group public Script Date: 10/04/96 16:08:40 ******/
/****** Object: Login sentry Script Date: 10/04/96 16:08:41 ******/
if not exists (select * from master..syslogins where name = 'sentry')
EXEC sp_addlogin 'sentry', 'sentry', 'sentry', null
GO
/****** Object: User sentry_user Script Date: 10/04/96 16:08:41 ******/
if not exists (select * from sysusers where name = 'sentry_user' and uid < 16382)
EXEC sp_adduser 'sentry', 'sentry_user', 'public'
GO
/****** Object: Table dbo.alerts Script Date: 10/04/96 16:08:44 ******/
if exists (select * from sysobjects where id = object_id('dbo.alerts') and sysstat & 0xf = 3)
drop table dbo.alerts
GO
CREATE TABLE alerts
(
id int NOT NULL ,
server varchar (20) NULL ,
alert_state int NULL ,
log_file int NULL ,
severity int NULL ,
eventno int NULL ,
source varchar (30) NULL ,
user_name varchar (20) NULL ,
mapi int NULL ,
strings varchar (36) NULL
)
GO
CREATE UNIQUE INDEX primarykey ON dbo.alerts(id)
GO
GRANT SELECT ON alerts TO sentry_user
GO
GRANT INSERT ON alerts TO sentry_user
GO
GRANT DELETE ON alerts TO sentry_user
GO
GRANT UPDATE ON alerts TO sentry_user
GO
/****** Object: Table dbo.events Script Date: 10/04/96 16:08:47 ******/
if exists (select * from sysobjects where id = object_id('dbo.events') and sysstat & 0xf = 3)
drop table dbo.events
GO
CREATE TABLE events
(
evtkey int NOT NULL ,
rectime datetime NULL,
evtime datetime NULL ,
log_file int NULL ,
severity int NULL ,
alert_state int NULL ,
server char (20) NULL ,
source char (50) NULL ,
category int NULL ,
euser char (20) NULL ,
eventno int NULL ,
evttext text NULL
)
GO
CREATE UNIQUE INDEX primarykey ON dbo.events(evtkey)
GO
GRANT SELECT ON events TO sentry_user
GO
GRANT INSERT ON events TO sentry_user
GO
GRANT DELETE ON events TO sentry_user
GO
GRANT UPDATE ON events TO sentry_user
GO
/****** Object: Table dbo.filters Script Date: 10/04/96 16:08:48 ******/
if exists (select * from sysobjects where id = object_id('dbo.filters') and sysstat & 0xf = 3)
drop table dbo.filters
GO
CREATE TABLE filters
(
id int NOT NULL ,
server char (20) NULL ,
log_file int NULL ,
severity int NULL ,
eventno int NULL ,
source char (36) NULL ,
user_name char (20) NULL
)
GO
CREATE UNIQUE INDEX primarykey ON dbo.filters(id)
GO
GRANT SELECT ON filters TO sentry_user
GO
GRANT INSERT ON filters TO sentry_user
GO
GRANT DELETE ON filters TO sentry_user
GO
GRANT UPDATE ON filters TO sentry_user
GO
/****** Object: Table dbo.servers Script Date: 10/04/96 16:08:50 ******/
if exists (select * from sysobjects where id = object_id('dbo.servers') and sysstat & 0xf = 3)
drop table dbo.servers
GO
CREATE TABLE servers
(
server char (20) NOT NULL ,
last_upd datetime NULL ,
last_cleared datetime NULL ,
alert_state int NULL ,
red_count int NULL ,
yellow_count int NULL ,
green_count int NULL
)
GO
CREATE UNIQUE INDEX primarykey ON dbo.servers(server)
GO
GRANT SELECT ON servers TO sentry_user
GO
GRANT INSERT ON servers TO sentry_user
GO
GRANT DELETE ON servers TO sentry_user
GO
GRANT UPDATE ON servers TO sentry_user
GO